package user.model;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import db.dao.UploadDao;
import db.dto.BookVo;
import db.dto.IsbnSaveDto;
import db.dto.SheetDto;

@Component("itemCatalog")
public class ItemCatalogImpl implements ItemCatalog{

	@Autowired
	private UploadDao uploadDao;
	@Override
	public void insertExcel(String xslPath) {
		 uploadDao.insertExcel(xslPath);
	}
	@Override
	public String getBooks(String snum) {
		// TODO Auto-generated method stub
		return uploadDao.getBooks(snum);
	}
	@Override
	public void update(String b_jemok, String num, String snum, String tablename) {
		uploadDao.update(b_jemok, num, snum, tablename);
	}
	@Override
	public void nameupdate(String b_name, String num, String snum, String tablename) {
		// TODO Auto-generated method stub
		uploadDao.nameupdate(b_name, num, snum, tablename);
	}
	@Override
	public String getSheetNumAndNames(String xslPath) {
		// TODO Auto-generated method stub
		return uploadDao.getSheetNumAndNames(xslPath);
	}
	@Override
	public String getSheetList(String tableName) {
			return uploadDao.getSheetList(tableName);
	}
	@Override
	public String getFileName(String snum) {
		
		return uploadDao.getFileName(snum);
	}
	@Override
	public void companyupdate(String b_company, String num, String snum, String tablename) {
		// TODO Auto-generated method stub
		uploadDao.companyupdate(b_company, num, snum, tablename);
	}
	@Override
	public void isbnSave(String snum,IsbnSaveDto dto) {
		// TODO Auto-generated method stub
		uploadDao.isbnSave(snum, dto);
	}
	@Override
	public void isbnupdate(String b_isbn, String num, String snum, String tablename) {
		// TODO Auto-generated method stub
		uploadDao.isbnupdate(b_isbn, num, snum, tablename);
	}
	@Override
	public void excelSave(String snum,String sname,String excelPath, String tablename) throws IOException {
		// TODO Auto-generated method stub
		uploadDao.excelSave(snum, sname, excelPath, tablename);
	}
	@Override
	public void alldelete(String excelPath, String tablename) {
		uploadDao.alldelete(excelPath, tablename);
	}
	@Override
	public boolean isLogin(String id, String pwd) {
		// TODO Auto-generated method stub
		return uploadDao.isLogin(id, pwd);
	}

}
